/*
 Navicat Premium Data Transfer

 Source Server         : localhost3309
 Source Server Type    : MySQL
 Source Server Version : 50720
 Source Host           : localhost:3309
 Source Schema         : ml_pay

 Target Server Type    : MySQL
 Target Server Version : 50720
 File Encoding         : 65001

 Date: 04/12/2020 16:16:08
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ml_pay_account
-- ----------------------------
DROP TABLE IF EXISTS `ml_pay_account`;
CREATE TABLE `ml_pay_account` (
  `account_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '账户ID主键',
  `name` varchar(255) NOT NULL COMMENT '账户名',
  `balance` decimal(20,0) NOT NULL COMMENT '账户金额',
  PRIMARY KEY (`account_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='支付账户表';

-- ----------------------------
-- Records of ml_pay_account
-- ----------------------------
BEGIN;
INSERT INTO `ml_pay_account` VALUES (1, 'fanghuaiming', 1000);
COMMIT;

-- ----------------------------
-- Table structure for ml_pay_msg
-- ----------------------------
DROP TABLE IF EXISTS `ml_pay_msg`;
CREATE TABLE `ml_pay_msg` (
  `pay_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '支付信息ID主键',
  `order_id` bigint(20) NOT NULL COMMENT '订单信息ID',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'status: 0 未发送 , 1 已发送 , 2 最终失败',
  `fail_count` int(10) NOT NULL DEFAULT '0' COMMENT '失败次数',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user` bigint(20) NOT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_user` bigint(20) NOT NULL COMMENT '更新人',
  `balance` decimal(20,0) NOT NULL COMMENT '支付金额',
  PRIMARY KEY (`pay_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='支付信息表';

-- ----------------------------
-- Records of ml_pay_msg
-- ----------------------------
BEGIN;
INSERT INTO `ml_pay_msg` VALUES (1, 1001, 1, 0, '2020-12-04 16:09:50', 1, '2020-12-04 16:09:50', 0, 200);
INSERT INTO `ml_pay_msg` VALUES (2, 1001, 1, 0, '2020-12-04 16:09:50', 1, '2020-12-04 16:09:50', 0, 200);
INSERT INTO `ml_pay_msg` VALUES (3, 1001, 1, 0, '2020-12-04 16:09:50', 1, '2020-12-04 16:09:50', 0, 200);
INSERT INTO `ml_pay_msg` VALUES (4, 1001, 1, 0, '2020-12-04 16:12:10', 1, '2020-12-04 16:12:10', 0, 200);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
